SET QUOTED_IDENTIFIER ON
GO
SET ANSI_NULLS ON
GO
CREATE PROCEDURE [dbo].[usp_GetCollInfoByCollId] ( @fdCollID VARCHAR(50) )
AS 
    SELECT  a.fdCollID ,
            a.fdCollName ,
            b.fdCollIntroduction
    FROM    dbo.FS_College AS a
            INNER JOIN dbo.JOL_CollegeIntroduction AS b
            ON a.fdCollID = b.fdCollID
    WHERE   a.fdCollID = @fdCollID
GO
